package com.lifesea.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class GhHisSchedulesExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public GhHisSchedulesExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andSchIdIsNull() {
            addCriterion("SCH_ID is null");
            return (Criteria) this;
        }

        public Criteria andSchIdIsNotNull() {
            addCriterion("SCH_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSchIdEqualTo(String value) {
            addCriterion("SCH_ID =", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdNotEqualTo(String value) {
            addCriterion("SCH_ID <>", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdGreaterThan(String value) {
            addCriterion("SCH_ID >", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdGreaterThanOrEqualTo(String value) {
            addCriterion("SCH_ID >=", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdLessThan(String value) {
            addCriterion("SCH_ID <", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdLessThanOrEqualTo(String value) {
            addCriterion("SCH_ID <=", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdLike(String value) {
            addCriterion("SCH_ID like", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdNotLike(String value) {
            addCriterion("SCH_ID not like", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdIn(List<String> values) {
            addCriterion("SCH_ID in", values, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdNotIn(List<String> values) {
            addCriterion("SCH_ID not in", values, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdBetween(String value1, String value2) {
            addCriterion("SCH_ID between", value1, value2, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdNotBetween(String value1, String value2) {
            addCriterion("SCH_ID not between", value1, value2, "schId");
            return (Criteria) this;
        }

        public Criteria andHosIdIsNull() {
            addCriterion("HOS_ID is null");
            return (Criteria) this;
        }

        public Criteria andHosIdIsNotNull() {
            addCriterion("HOS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andHosIdEqualTo(Integer value) {
            addCriterion("HOS_ID =", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdNotEqualTo(Integer value) {
            addCriterion("HOS_ID <>", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdGreaterThan(Integer value) {
            addCriterion("HOS_ID >", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("HOS_ID >=", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdLessThan(Integer value) {
            addCriterion("HOS_ID <", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdLessThanOrEqualTo(Integer value) {
            addCriterion("HOS_ID <=", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdIn(List<Integer> values) {
            addCriterion("HOS_ID in", values, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdNotIn(List<Integer> values) {
            addCriterion("HOS_ID not in", values, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdBetween(Integer value1, Integer value2) {
            addCriterion("HOS_ID between", value1, value2, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdNotBetween(Integer value1, Integer value2) {
            addCriterion("HOS_ID not between", value1, value2, "hosId");
            return (Criteria) this;
        }

        public Criteria andBranchIdIsNull() {
            addCriterion("BRANCH_ID is null");
            return (Criteria) this;
        }

        public Criteria andBranchIdIsNotNull() {
            addCriterion("BRANCH_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBranchIdEqualTo(Integer value) {
            addCriterion("BRANCH_ID =", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdNotEqualTo(Integer value) {
            addCriterion("BRANCH_ID <>", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdGreaterThan(Integer value) {
            addCriterion("BRANCH_ID >", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("BRANCH_ID >=", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdLessThan(Integer value) {
            addCriterion("BRANCH_ID <", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdLessThanOrEqualTo(Integer value) {
            addCriterion("BRANCH_ID <=", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdIn(List<Integer> values) {
            addCriterion("BRANCH_ID in", values, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdNotIn(List<Integer> values) {
            addCriterion("BRANCH_ID not in", values, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdBetween(Integer value1, Integer value2) {
            addCriterion("BRANCH_ID between", value1, value2, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdNotBetween(Integer value1, Integer value2) {
            addCriterion("BRANCH_ID not between", value1, value2, "branchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdIsNull() {
            addCriterion("HIS_SCH_ID is null");
            return (Criteria) this;
        }

        public Criteria andHisSchIdIsNotNull() {
            addCriterion("HIS_SCH_ID is not null");
            return (Criteria) this;
        }

        public Criteria andHisSchIdEqualTo(String value) {
            addCriterion("HIS_SCH_ID =", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdNotEqualTo(String value) {
            addCriterion("HIS_SCH_ID <>", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdGreaterThan(String value) {
            addCriterion("HIS_SCH_ID >", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdGreaterThanOrEqualTo(String value) {
            addCriterion("HIS_SCH_ID >=", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdLessThan(String value) {
            addCriterion("HIS_SCH_ID <", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdLessThanOrEqualTo(String value) {
            addCriterion("HIS_SCH_ID <=", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdLike(String value) {
            addCriterion("HIS_SCH_ID like", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdNotLike(String value) {
            addCriterion("HIS_SCH_ID not like", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdIn(List<String> values) {
            addCriterion("HIS_SCH_ID in", values, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdNotIn(List<String> values) {
            addCriterion("HIS_SCH_ID not in", values, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdBetween(String value1, String value2) {
            addCriterion("HIS_SCH_ID between", value1, value2, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdNotBetween(String value1, String value2) {
            addCriterion("HIS_SCH_ID not between", value1, value2, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdIsNull() {
            addCriterion("HIS_DEPT_ID is null");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdIsNotNull() {
            addCriterion("HIS_DEPT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdEqualTo(String value) {
            addCriterion("HIS_DEPT_ID =", value, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdNotEqualTo(String value) {
            addCriterion("HIS_DEPT_ID <>", value, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdGreaterThan(String value) {
            addCriterion("HIS_DEPT_ID >", value, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdGreaterThanOrEqualTo(String value) {
            addCriterion("HIS_DEPT_ID >=", value, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdLessThan(String value) {
            addCriterion("HIS_DEPT_ID <", value, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdLessThanOrEqualTo(String value) {
            addCriterion("HIS_DEPT_ID <=", value, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdLike(String value) {
            addCriterion("HIS_DEPT_ID like", value, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdNotLike(String value) {
            addCriterion("HIS_DEPT_ID not like", value, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdIn(List<String> values) {
            addCriterion("HIS_DEPT_ID in", values, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdNotIn(List<String> values) {
            addCriterion("HIS_DEPT_ID not in", values, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdBetween(String value1, String value2) {
            addCriterion("HIS_DEPT_ID between", value1, value2, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDeptIdNotBetween(String value1, String value2) {
            addCriterion("HIS_DEPT_ID not between", value1, value2, "hisDeptId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdIsNull() {
            addCriterion("HIS_DOC_ID is null");
            return (Criteria) this;
        }

        public Criteria andHisDocIdIsNotNull() {
            addCriterion("HIS_DOC_ID is not null");
            return (Criteria) this;
        }

        public Criteria andHisDocIdEqualTo(String value) {
            addCriterion("HIS_DOC_ID =", value, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdNotEqualTo(String value) {
            addCriterion("HIS_DOC_ID <>", value, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdGreaterThan(String value) {
            addCriterion("HIS_DOC_ID >", value, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdGreaterThanOrEqualTo(String value) {
            addCriterion("HIS_DOC_ID >=", value, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdLessThan(String value) {
            addCriterion("HIS_DOC_ID <", value, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdLessThanOrEqualTo(String value) {
            addCriterion("HIS_DOC_ID <=", value, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdLike(String value) {
            addCriterion("HIS_DOC_ID like", value, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdNotLike(String value) {
            addCriterion("HIS_DOC_ID not like", value, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdIn(List<String> values) {
            addCriterion("HIS_DOC_ID in", values, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdNotIn(List<String> values) {
            addCriterion("HIS_DOC_ID not in", values, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdBetween(String value1, String value2) {
            addCriterion("HIS_DOC_ID between", value1, value2, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andHisDocIdNotBetween(String value1, String value2) {
            addCriterion("HIS_DOC_ID not between", value1, value2, "hisDocId");
            return (Criteria) this;
        }

        public Criteria andSchDateIsNull() {
            addCriterion("SCH_DATE is null");
            return (Criteria) this;
        }

        public Criteria andSchDateIsNotNull() {
            addCriterion("SCH_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andSchDateEqualTo(Date value) {
            addCriterionForJDBCDate("SCH_DATE =", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("SCH_DATE <>", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateGreaterThan(Date value) {
            addCriterionForJDBCDate("SCH_DATE >", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("SCH_DATE >=", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateLessThan(Date value) {
            addCriterionForJDBCDate("SCH_DATE <", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("SCH_DATE <=", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateIn(List<Date> values) {
            addCriterionForJDBCDate("SCH_DATE in", values, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("SCH_DATE not in", values, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("SCH_DATE between", value1, value2, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("SCH_DATE not between", value1, value2, "schDate");
            return (Criteria) this;
        }

        public Criteria andTimeFlagIsNull() {
            addCriterion("TIME_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andTimeFlagIsNotNull() {
            addCriterion("TIME_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andTimeFlagEqualTo(Integer value) {
            addCriterion("TIME_FLAG =", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagNotEqualTo(Integer value) {
            addCriterion("TIME_FLAG <>", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagGreaterThan(Integer value) {
            addCriterion("TIME_FLAG >", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("TIME_FLAG >=", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagLessThan(Integer value) {
            addCriterion("TIME_FLAG <", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagLessThanOrEqualTo(Integer value) {
            addCriterion("TIME_FLAG <=", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagIn(List<Integer> values) {
            addCriterion("TIME_FLAG in", values, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagNotIn(List<Integer> values) {
            addCriterion("TIME_FLAG not in", values, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagBetween(Integer value1, Integer value2) {
            addCriterion("TIME_FLAG between", value1, value2, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("TIME_FLAG not between", value1, value2, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTotalIsNull() {
            addCriterion("TOTAL is null");
            return (Criteria) this;
        }

        public Criteria andTotalIsNotNull() {
            addCriterion("TOTAL is not null");
            return (Criteria) this;
        }

        public Criteria andTotalEqualTo(Integer value) {
            addCriterion("TOTAL =", value, "total");
            return (Criteria) this;
        }

        public Criteria andTotalNotEqualTo(Integer value) {
            addCriterion("TOTAL <>", value, "total");
            return (Criteria) this;
        }

        public Criteria andTotalGreaterThan(Integer value) {
            addCriterion("TOTAL >", value, "total");
            return (Criteria) this;
        }

        public Criteria andTotalGreaterThanOrEqualTo(Integer value) {
            addCriterion("TOTAL >=", value, "total");
            return (Criteria) this;
        }

        public Criteria andTotalLessThan(Integer value) {
            addCriterion("TOTAL <", value, "total");
            return (Criteria) this;
        }

        public Criteria andTotalLessThanOrEqualTo(Integer value) {
            addCriterion("TOTAL <=", value, "total");
            return (Criteria) this;
        }

        public Criteria andTotalIn(List<Integer> values) {
            addCriterion("TOTAL in", values, "total");
            return (Criteria) this;
        }

        public Criteria andTotalNotIn(List<Integer> values) {
            addCriterion("TOTAL not in", values, "total");
            return (Criteria) this;
        }

        public Criteria andTotalBetween(Integer value1, Integer value2) {
            addCriterion("TOTAL between", value1, value2, "total");
            return (Criteria) this;
        }

        public Criteria andTotalNotBetween(Integer value1, Integer value2) {
            addCriterion("TOTAL not between", value1, value2, "total");
            return (Criteria) this;
        }

        public Criteria andOverCountIsNull() {
            addCriterion("OVER_COUNT is null");
            return (Criteria) this;
        }

        public Criteria andOverCountIsNotNull() {
            addCriterion("OVER_COUNT is not null");
            return (Criteria) this;
        }

        public Criteria andOverCountEqualTo(Integer value) {
            addCriterion("OVER_COUNT =", value, "overCount");
            return (Criteria) this;
        }

        public Criteria andOverCountNotEqualTo(Integer value) {
            addCriterion("OVER_COUNT <>", value, "overCount");
            return (Criteria) this;
        }

        public Criteria andOverCountGreaterThan(Integer value) {
            addCriterion("OVER_COUNT >", value, "overCount");
            return (Criteria) this;
        }

        public Criteria andOverCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("OVER_COUNT >=", value, "overCount");
            return (Criteria) this;
        }

        public Criteria andOverCountLessThan(Integer value) {
            addCriterion("OVER_COUNT <", value, "overCount");
            return (Criteria) this;
        }

        public Criteria andOverCountLessThanOrEqualTo(Integer value) {
            addCriterion("OVER_COUNT <=", value, "overCount");
            return (Criteria) this;
        }

        public Criteria andOverCountIn(List<Integer> values) {
            addCriterion("OVER_COUNT in", values, "overCount");
            return (Criteria) this;
        }

        public Criteria andOverCountNotIn(List<Integer> values) {
            addCriterion("OVER_COUNT not in", values, "overCount");
            return (Criteria) this;
        }

        public Criteria andOverCountBetween(Integer value1, Integer value2) {
            addCriterion("OVER_COUNT between", value1, value2, "overCount");
            return (Criteria) this;
        }

        public Criteria andOverCountNotBetween(Integer value1, Integer value2) {
            addCriterion("OVER_COUNT not between", value1, value2, "overCount");
            return (Criteria) this;
        }

        public Criteria andSchTypeIsNull() {
            addCriterion("SCH_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andSchTypeIsNotNull() {
            addCriterion("SCH_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andSchTypeEqualTo(Integer value) {
            addCriterion("SCH_TYPE =", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeNotEqualTo(Integer value) {
            addCriterion("SCH_TYPE <>", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeGreaterThan(Integer value) {
            addCriterion("SCH_TYPE >", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("SCH_TYPE >=", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeLessThan(Integer value) {
            addCriterion("SCH_TYPE <", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeLessThanOrEqualTo(Integer value) {
            addCriterion("SCH_TYPE <=", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeIn(List<Integer> values) {
            addCriterion("SCH_TYPE in", values, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeNotIn(List<Integer> values) {
            addCriterion("SCH_TYPE not in", values, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeBetween(Integer value1, Integer value2) {
            addCriterion("SCH_TYPE between", value1, value2, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("SCH_TYPE not between", value1, value2, "schType");
            return (Criteria) this;
        }

        public Criteria andRegFeeIsNull() {
            addCriterion("REG_FEE is null");
            return (Criteria) this;
        }

        public Criteria andRegFeeIsNotNull() {
            addCriterion("REG_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andRegFeeEqualTo(Integer value) {
            addCriterion("REG_FEE =", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeNotEqualTo(Integer value) {
            addCriterion("REG_FEE <>", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeGreaterThan(Integer value) {
            addCriterion("REG_FEE >", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("REG_FEE >=", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeLessThan(Integer value) {
            addCriterion("REG_FEE <", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeLessThanOrEqualTo(Integer value) {
            addCriterion("REG_FEE <=", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeIn(List<Integer> values) {
            addCriterion("REG_FEE in", values, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeNotIn(List<Integer> values) {
            addCriterion("REG_FEE not in", values, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeBetween(Integer value1, Integer value2) {
            addCriterion("REG_FEE between", value1, value2, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeNotBetween(Integer value1, Integer value2) {
            addCriterion("REG_FEE not between", value1, value2, "regFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeIsNull() {
            addCriterion("TREAT_FEE is null");
            return (Criteria) this;
        }

        public Criteria andTreatFeeIsNotNull() {
            addCriterion("TREAT_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andTreatFeeEqualTo(Integer value) {
            addCriterion("TREAT_FEE =", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeNotEqualTo(Integer value) {
            addCriterion("TREAT_FEE <>", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeGreaterThan(Integer value) {
            addCriterion("TREAT_FEE >", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("TREAT_FEE >=", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeLessThan(Integer value) {
            addCriterion("TREAT_FEE <", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeLessThanOrEqualTo(Integer value) {
            addCriterion("TREAT_FEE <=", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeIn(List<Integer> values) {
            addCriterion("TREAT_FEE in", values, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeNotIn(List<Integer> values) {
            addCriterion("TREAT_FEE not in", values, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeBetween(Integer value1, Integer value2) {
            addCriterion("TREAT_FEE between", value1, value2, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeNotBetween(Integer value1, Integer value2) {
            addCriterion("TREAT_FEE not between", value1, value2, "treatFee");
            return (Criteria) this;
        }

        public Criteria andJobTitleIsNull() {
            addCriterion("JOB_TITLE is null");
            return (Criteria) this;
        }

        public Criteria andJobTitleIsNotNull() {
            addCriterion("JOB_TITLE is not null");
            return (Criteria) this;
        }

        public Criteria andJobTitleEqualTo(String value) {
            addCriterion("JOB_TITLE =", value, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleNotEqualTo(String value) {
            addCriterion("JOB_TITLE <>", value, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleGreaterThan(String value) {
            addCriterion("JOB_TITLE >", value, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleGreaterThanOrEqualTo(String value) {
            addCriterion("JOB_TITLE >=", value, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleLessThan(String value) {
            addCriterion("JOB_TITLE <", value, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleLessThanOrEqualTo(String value) {
            addCriterion("JOB_TITLE <=", value, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleLike(String value) {
            addCriterion("JOB_TITLE like", value, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleNotLike(String value) {
            addCriterion("JOB_TITLE not like", value, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleIn(List<String> values) {
            addCriterion("JOB_TITLE in", values, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleNotIn(List<String> values) {
            addCriterion("JOB_TITLE not in", values, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleBetween(String value1, String value2) {
            addCriterion("JOB_TITLE between", value1, value2, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andJobTitleNotBetween(String value1, String value2) {
            addCriterion("JOB_TITLE not between", value1, value2, "jobTitle");
            return (Criteria) this;
        }

        public Criteria andSchStatusIsNull() {
            addCriterion("SCH_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andSchStatusIsNotNull() {
            addCriterion("SCH_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andSchStatusEqualTo(Integer value) {
            addCriterion("SCH_STATUS =", value, "schStatus");
            return (Criteria) this;
        }

        public Criteria andSchStatusNotEqualTo(Integer value) {
            addCriterion("SCH_STATUS <>", value, "schStatus");
            return (Criteria) this;
        }

        public Criteria andSchStatusGreaterThan(Integer value) {
            addCriterion("SCH_STATUS >", value, "schStatus");
            return (Criteria) this;
        }

        public Criteria andSchStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("SCH_STATUS >=", value, "schStatus");
            return (Criteria) this;
        }

        public Criteria andSchStatusLessThan(Integer value) {
            addCriterion("SCH_STATUS <", value, "schStatus");
            return (Criteria) this;
        }

        public Criteria andSchStatusLessThanOrEqualTo(Integer value) {
            addCriterion("SCH_STATUS <=", value, "schStatus");
            return (Criteria) this;
        }

        public Criteria andSchStatusIn(List<Integer> values) {
            addCriterion("SCH_STATUS in", values, "schStatus");
            return (Criteria) this;
        }

        public Criteria andSchStatusNotIn(List<Integer> values) {
            addCriterion("SCH_STATUS not in", values, "schStatus");
            return (Criteria) this;
        }

        public Criteria andSchStatusBetween(Integer value1, Integer value2) {
            addCriterion("SCH_STATUS between", value1, value2, "schStatus");
            return (Criteria) this;
        }

        public Criteria andSchStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("SCH_STATUS not between", value1, value2, "schStatus");
            return (Criteria) this;
        }

        public Criteria andIsTimeIsNull() {
            addCriterion("IS_TIME is null");
            return (Criteria) this;
        }

        public Criteria andIsTimeIsNotNull() {
            addCriterion("IS_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andIsTimeEqualTo(Short value) {
            addCriterion("IS_TIME =", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeNotEqualTo(Short value) {
            addCriterion("IS_TIME <>", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeGreaterThan(Short value) {
            addCriterion("IS_TIME >", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeGreaterThanOrEqualTo(Short value) {
            addCriterion("IS_TIME >=", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeLessThan(Short value) {
            addCriterion("IS_TIME <", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeLessThanOrEqualTo(Short value) {
            addCriterion("IS_TIME <=", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeIn(List<Short> values) {
            addCriterion("IS_TIME in", values, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeNotIn(List<Short> values) {
            addCriterion("IS_TIME not in", values, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeBetween(Short value1, Short value2) {
            addCriterion("IS_TIME between", value1, value2, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeNotBetween(Short value1, Short value2) {
            addCriterion("IS_TIME not between", value1, value2, "isTime");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table gh_his_schedules
     *
     * @mbggenerated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}